Release 10.1A: OpenEdge Development:
Programming Interfaces

Fetching records

After you define a set of records, Progress must fetch the records. How Progress fetches records depends in part on which statements you use to fetch the records. Table 1–3 summarizes the differences in record fetching between the FIND, FOR EACH, OPEN QUERY, and PRESELECT statements.

Table 1–3: Record fetching 

Statement to define set of records	Statement to fetch the records	Structure used to locate records
FIND	FIND	Index
FOR EACH	FOR EACH	Results List or Index
OPEN QUERY	GET	Results List or Index
DO PRESELECT or REPEAT PRESELECT	FIND	Results List